package com.rimi.dao.impl;

import com.rimi.bean.Menu;
import com.rimi.dao.MenuDao;
import com.rimi.util.JdbcUtil;

import java.util.List;

/**
 * @author chengliang
 */
public class MenuDaoImpl extends JdbcUtil implements MenuDao {

    @Override
    public List<Menu> selectMenuListByRoleId(int roleId) {
        return executeQueryList(Menu.class,"select m.* from role_menu_tb rm  inner join menu_tb m " +
                "on rm.menu_id = m.menu_id where role_id = ?",roleId);
    }

}
